-- #lazgen HEADER#
/*
	spTechnologyList.

	This procedure returns a list of all Technology from the database.
*/
SET ANSI_NULLS ON
GO

ALTER PROCEDURE [spTechnologyList] AS
		
BEGIN
-- #endlazgen HEADER#

-- #lazgen BODY#

SELECT
	[technology].[Id],
	[technology].[Title],
	[technology].[Description],
	[technology].[ExpertiseLevelId],
	[technology].[Created],
	[technology].[Modified],
	[expertiselevel].[Title]
FROM
	[tblTechnology] [technology]
	LEFT JOIN [tblExpertiseLevel] [expertiselevel] ON [technology].[ExpertiseLevelId] = [expertiselevel].[Id]

-- #endlazgen BODY#


-- #lazgen FOOTER#

END

GO

SET ANSI_NULLS OFF
GO   
-- #endlazgen FOOTER#
